FO_PtLocations
Most key elements are loaded from LIS. The update process might update all available fields or only add new definitions depending on the site’s needs.
Field | Type | Notes |
---|---|---|
PtLocations_ID |
int |
ID field, a counter. Unique |
PtLocCode |
varchar(20) |
Patient location code. Enter a valid LIS patient location code. |
PtLocDescription |
varchar(80) |
Description of patient location code. |
PtLocType |
varchar(20) |
Patient location type. Enter a valid patient location type for LIS systems. Sunquest values are 1,2,3,4 |
LocStatus |
varchar(50) |
Location status for LIS. Enter an allowed value. Allowed values: A = Active I = Inactive |
FacilityID |
varchar(50) |
Default facility ID for this patient location. Enter a valid facility ID. |
LocAccount |
varchar(50) |
Default account for this location. Enter a valid account. |
Tel |
varchar(50) |
Phone number for location. |
Fax |
varchar(50) |
Fax number for location. |
Active |
varchar(50) |
Location status for FAST. Enter an allowed value. Allowed values: A = Active I = Inactive |
ClientPopup |
varchar(255) |
Location specific message for client use only. This text is presented by FASTas a message when the client user orders a test. |
LabPopup |
varchar(255) |
Location specific message for lab use only. This text is presented by FASTas a message when the user orders a test. |
AutoOrderTests |
varchar(255) |
Defines the list of test codes the system will automatically order when the user places the first order on the order screen and this location code is present. Multidimensional pipe delimited value, with leading and trailing pipes. Enter valid test codes separated by pipes. |
RptTriggerSubscriptionID |
varchar(50) |
Default RptTriggerSubscriptionID for location. Enter a valid RptTriggerSubscriptionID. Used in report delivery. |
|
varchar(80) |
Email address for location. |
Pager |
varchar(80) |
Pager number. |
Add1 |
varchar(80) |
First address line. Informational |
Add2 |
varchar(80) |
Second address line. Informational |
City |
varchar(80) |
City. Informational |
St |
varchar(80) |
State. Informational |
ZipCode |
varchar(50) |
Zip code. Informational |
CreateDate |
datetime |
System timestamp when record is first created. |
EditDate |
datetime |
System timestamp when record is edited. |
RequiresRoomBedEntry |
bit |
Bit field to indicate if room / bed information is required. Enter 0 or 1 0 = no room / bed required 1 = room / bed required |
FINCompanyCode |
varchar(50) |
Company code sent to FIN for orders from this location. Enter a valid FIN Company code. |
Country |
varchar(50) |
Country. Informational |
LabCode |
varchar(80) |
Default lab code for this location. Enter a valid lab code. |
SourceSystem |
varchar(80) |
Default system/vendor/version ID for this location. Enter a valid ID. Connects to the organization source system definitions. |